/ Celestin Apprentice 7 / Apprentice-Release7.iso / Demos / A.D. Software / OOFILE 1.3b4d6.sit / OOFILE 1.3b4d6 / MacCodeWarriorDemo1.3b4d6 / docs / samples / ooftst12.cpp

< prev

next >

MacOS 8.1

Win98

DOS

browse contents

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 0c 6f 6f 66 74 73 74 | 31 32 2e 63 70 70 00 00 |..ooftst|12.cpp..|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 54 45 58 54 43 57 49 | 45 00 00 00 00 00 00 00 |.TEXTCWI|E.......|
|00000050| 00 00 00 00 00 10 29 00 | 00 02 70 af 53 9b 1c af |......).|..p.S...|
|00000060| 53 9b 1c 00 00 0a 00 00 | 00 00 00 00 00 00 00 00 |S.......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 c5 4f 00 00 |........|.....O..|
|00000080| 2f 2f 20 43 6f 70 79 72 | 69 67 68 74 20 31 39 39 |// Copyr|ight 199|
|00000090| 35 20 41 2e 44 2e 20 53 | 6f 66 74 77 61 72 65 2e |5 A.D. S|oftware.|
|000000a0| 20 41 6c 6c 20 52 69 67 | 68 74 73 20 52 65 73 65 | All Rig|hts Rese|
|000000b0| 72 76 65 64 0d 0d 2f 2f | 20 4f 4f 46 54 45 53 54 |rved..//| OOFTEST|
|000000c0| 31 32 0d 0d 2f 2f 20 54 | 68 69 73 20 73 61 6d 70 |12..// T|his samp|
|000000d0| 6c 65 20 74 65 73 74 73 | 20 74 68 65 20 63 6f 6d |le tests| the com|
|000000e0| 70 6f 75 6e 64 20 69 6e | 64 65 78 65 73 20 62 79 |pound in|dexes by|
|000000f0| 20 63 72 65 61 74 69 6e | 67 20 61 20 73 69 6e 67 | creatin|g a sing|
|00000100| 6c 65 20 74 61 62 6c 65 | 0d 2f 2f 20 61 6e 64 20 |le table|.// and |
|00000110| 73 74 6f 72 69 6e 67 20 | 61 6e 64 20 72 65 74 72 |storing |and retr|
|00000120| 69 65 76 69 6e 67 20 69 | 6e 64 65 78 65 64 20 64 |ieving i|ndexed d|
|00000130| 61 74 61 2e 0d 0d 2f 2f | 20 53 69 6d 70 6c 65 20 |ata...//| Simple |
|00000140| 73 74 72 65 61 6d 20 49 | 2f 4f 20 69 73 20 75 73 |stream I|/O is us|
|00000150| 65 64 20 74 6f 20 69 6e | 74 65 72 61 63 74 20 77 |ed to in|teract w|
|00000160| 69 74 68 20 74 68 65 20 | 75 73 65 72 2e 0d 0d 23 |ith the |user...#|
|00000170| 69 6e 63 6c 75 64 65 20 | 22 6f 6f 66 69 6c 65 2e |include |"oofile.|
|00000180| 68 22 0d 0d 43 4c 41 53 | 53 5f 54 41 42 4c 45 28 |h"..CLAS|S_TABLE(|
|00000190| 64 62 50 65 6f 70 6c 65 | 29 0d 09 64 62 43 68 61 |dbPeople|)..dbCha|
|000001a0| 72 09 09 4c 61 73 74 4e | 61 6d 65 2c 20 4f 74 68 |r..LastN|ame, Oth|
|000001b0| 65 72 4e 61 6d 65 73 2c | 20 44 65 70 61 72 74 6d |erNames,| Departm|
|000001c0| 65 6e 74 43 6f 64 65 2c | 20 50 72 6f 6a 65 63 74 |entCode,| Project|
|000001d0| 43 6f 64 65 3b 0d 09 64 | 62 4c 6f 6e 67 09 09 53 |Code;..d|bLong..S|
|000001e0| 61 6c 61 72 79 3b 0d 09 | 64 62 43 6f 6d 70 6f 75 |alary;..|dbCompou|
|000001f0| 6e 64 46 69 65 6c 64 09 | 43 6f 6d 62 69 6e 65 64 |ndField.|Combined|
|00000200| 4e 61 6d 65 73 2c 20 4e | 61 6d 65 41 6e 64 53 61 |Names, N|ameAndSa|
|00000210| 6c 61 72 79 2c 20 4a 6f | 62 43 6f 64 65 3b 0d 09 |lary, Jo|bCode;..|
|00000220| 64 62 55 73 68 6f 72 74 | 09 53 74 61 72 74 65 64 |dbUshort|.Started|
|00000230| 59 65 61 72 3b 0d 09 0d | 0d 09 64 62 50 65 6f 70 |Year;...|..dbPeop|
|00000240| 6c 65 28 29 20 3a 0d 09 | 09 09 09 64 62 54 61 62 |le() :..|...dbTab|
|00000250| 6c 65 28 22 50 65 6f 70 | 6c 65 22 29 2c 0d 09 09 |le("Peop|le"),...|
|00000260| 09 09 4c 61 73 74 4e 61 | 6d 65 28 33 39 2c 20 22 |..LastNa|me(39, "|
|00000270| 4c 61 73 74 20 4e 61 6d | 65 22 29 2c 0d 09 09 09 |Last Nam|e"),....|
|00000280| 09 4f 74 68 65 72 4e 61 | 6d 65 73 28 37 39 2c 20 |.OtherNa|mes(79, |
|00000290| 22 4f 74 68 65 72 20 4e | 61 6d 65 73 22 2c 20 6b |"Other N|ames", k|
|000002a0| 49 6e 64 65 78 43 6f 6d | 70 72 65 73 73 29 2c 0d |IndexCom|press),.|
|000002b0| 09 09 09 09 44 65 70 61 | 72 74 6d 65 6e 74 43 6f |....Depa|rtmentCo|
|000002c0| 64 65 28 33 2c 20 22 44 | 65 70 74 2e 20 43 6f 64 |de(3, "D|ept. Cod|
|000002d0| 65 22 29 2c 20 0d 09 09 | 09 09 50 72 6f 6a 65 63 |e"), ...|..Projec|
|000002e0| 74 43 6f 64 65 28 34 2c | 20 22 50 72 6f 6a 2e 20 |tCode(4,| "Proj. |
|000002f0| 43 6f 64 65 22 29 2c 0d | 09 09 09 09 53 61 6c 61 |Code"),.|....Sala|
|00000300| 72 79 28 22 53 61 6c 61 | 72 79 22 29 2c 0d 09 09 |ry("Sala|ry"),...|
|00000310| 09 09 43 6f 6d 62 69 6e | 65 64 4e 61 6d 65 73 28 |..Combin|edNames(|
|00000320| 22 43 6f 6d 62 69 6e 65 | 64 20 4e 61 6d 65 73 22 |"Combine|d Names"|
|00000330| 29 2c 0d 09 09 09 09 4e | 61 6d 65 41 6e 64 53 61 |),.....N|ameAndSa|
|00000340| 6c 61 72 79 28 22 4e 61 | 6d 65 20 26 20 53 61 6c |lary("Na|me & Sal|
|00000350| 61 72 79 22 29 2c 0d 09 | 09 09 09 4a 6f 62 43 6f |ary"),..|...JobCo|
|00000360| 64 65 28 22 4a 6f 62 20 | 43 6f 64 65 22 29 2c 0d |de("Job |Code"),.|
|00000370| 09 09 09 09 53 74 61 72 | 74 65 64 59 65 61 72 28 |....Star|tedYear(|
|00000380| 22 53 74 61 72 74 65 64 | 20 59 65 61 72 22 29 0d |"Started| Year").|
|00000390| 09 09 09 09 0d 7b 0d 09 | 43 6f 6d 62 69 6e 65 64 |.....{..|Combined|
|000003a0| 4e 61 6d 65 73 20 3c 3c | 20 4c 61 73 74 4e 61 6d |Names <<| LastNam|
|000003b0| 65 20 3c 3c 20 4f 74 68 | 65 72 4e 61 6d 65 73 3b |e << Oth|erNames;|
|000003c0| 0d 09 43 6f 6d 62 69 6e | 65 64 4e 61 6d 65 73 2e |..Combin|edNames.|
|000003d0| 69 6e 64 65 78 28 6b 49 | 6e 64 65 78 4e 6f 44 75 |index(kI|ndexNoDu|
|000003e0| 70 73 29 3b 20 20 2f 2f | 20 6f 72 64 65 72 20 6f |ps);  //| order o|
|000003f0| 66 20 74 68 65 73 65 20 | 74 77 6f 20 6c 69 6e 65 |f these |two line|
|00000400| 73 20 69 73 20 6e 6f 74 | 20 73 69 67 6e 69 66 69 |s is not| signifi|
|00000410| 63 61 6e 74 0d 09 0d 09 | 4e 61 6d 65 41 6e 64 53 |cant....|NameAndS|
|00000420| 61 6c 61 72 79 20 3c 3c | 20 4c 61 73 74 4e 61 6d |alary <<| LastNam|
|00000430| 65 20 3e 3e 20 53 61 6c | 61 72 79 3b 0d 09 4e 61 |e >> Sal|ary;..Na|
|00000440| 6d 65 41 6e 64 53 61 6c | 61 72 79 2e 69 6e 64 65 |meAndSal|ary.inde|
|00000450| 78 28 6b 49 6e 64 65 78 | 43 6f 6d 70 72 65 73 73 |x(kIndex|Compress|
|00000460| 29 3b 20 20 0d 09 0d 09 | 4a 6f 62 43 6f 64 65 20 |);  ....|JobCode |
|00000470| 3c 3c 20 44 65 70 61 72 | 74 6d 65 6e 74 43 6f 64 |<< Depar|tmentCod|
|00000480| 65 20 3c 3c 20 50 72 6f | 6a 65 63 74 43 6f 64 65 |e << Pro|jectCode|
|00000490| 20 3c 3c 20 53 74 61 72 | 74 65 64 59 65 61 72 3b | << Star|tedYear;|
|000004a0| 0d 09 4a 6f 62 43 6f 64 | 65 2e 69 6e 64 65 78 28 |..JobCod|e.index(|
|000004b0| 6b 49 6e 64 65 78 65 64 | 29 3b 0d 7d 3b 0d 09 0d |kIndexed|);.};...|
|000004c0| 2f 2f 20 6d 79 20 6f 77 | 6e 20 64 61 74 61 20 65 |// my ow|n data e|
|000004d0| 6e 74 72 79 20 70 72 6f | 63 65 64 75 72 65 73 0d |ntry pro|cedures.|
|000004e0| 09 76 6f 69 64 20 41 64 | 64 28 63 6f 6e 73 74 20 |.void Ad|d(const |
|000004f0| 63 68 61 72 20 2a 6c 6e | 61 6d 65 2c 20 63 6f 6e |char *ln|ame, con|
|00000500| 73 74 20 63 68 61 72 20 | 2a 6f 6e 61 6d 65 2c 20 |st char |*oname, |
|00000510| 63 6f 6e 73 74 20 6c 6f | 6e 67 20 73 61 6c 61 72 |const lo|ng salar|
|00000520| 79 2c 20 63 6f 6e 73 74 | 20 63 68 61 72 20 2a 64 |y, const| char *d|
|00000530| 65 70 74 2c 20 63 6f 6e | 73 74 20 63 68 61 72 20 |ept, con|st char |
|00000540| 2a 70 72 6f 6a 2c 20 63 | 6f 6e 73 74 20 75 6e 73 |*proj, c|onst uns|
|00000550| 69 67 6e 65 64 20 73 68 | 6f 72 74 20 79 65 61 72 |igned sh|ort year|
|00000560| 29 3b 0d 7d 3b 0d 0d 76 | 6f 69 64 20 64 62 50 65 |);.};..v|oid dbPe|
|00000570| 6f 70 6c 65 3a 3a 41 64 | 64 28 63 6f 6e 73 74 20 |ople::Ad|d(const |
|00000580| 63 68 61 72 20 2a 6c 6e | 61 6d 65 2c 20 63 6f 6e |char *ln|ame, con|
|00000590| 73 74 20 63 68 61 72 20 | 2a 6f 6e 61 6d 65 2c 20 |st char |*oname, |
|000005a0| 63 6f 6e 73 74 20 6c 6f | 6e 67 20 73 61 6c 61 72 |const lo|ng salar|
|000005b0| 79 2c 20 63 6f 6e 73 74 | 20 63 68 61 72 20 2a 64 |y, const| char *d|
|000005c0| 65 70 74 2c 20 63 6f 6e | 73 74 20 63 68 61 72 20 |ept, con|st char |
|000005d0| 2a 70 72 6f 6a 2c 20 63 | 6f 6e 73 74 20 75 6e 73 |*proj, c|onst uns|
|000005e0| 69 67 6e 65 64 20 73 68 | 6f 72 74 20 79 65 61 72 |igned sh|ort year|
|000005f0| 29 0d 7b 0d 09 6e 65 77 | 52 65 63 6f 72 64 28 29 |).{..new|Record()|
|00000600| 3b 0d 09 4c 61 73 74 4e | 61 6d 65 20 3d 20 6c 6e |;..LastN|ame = ln|
|00000610| 61 6d 65 3b 0d 09 4f 74 | 68 65 72 4e 61 6d 65 73 |ame;..Ot|herNames|
|00000620| 20 3d 20 6f 6e 61 6d 65 | 3b 0d 09 53 61 6c 61 72 | = oname|;..Salar|
|00000630| 79 20 3d 20 73 61 6c 61 | 72 79 3b 0d 09 44 65 70 |y = sala|ry;..Dep|
|00000640| 61 72 74 6d 65 6e 74 43 | 6f 64 65 20 3d 20 64 65 |artmentC|ode = de|
|00000650| 70 74 3b 0d 09 50 72 6f | 6a 65 63 74 43 6f 64 65 |pt;..Pro|jectCode|
|00000660| 20 3d 20 70 72 6f 6a 3b | 0d 09 53 74 61 72 74 65 | = proj;|..Starte|
|00000670| 64 59 65 61 72 20 3d 20 | 79 65 61 72 3b 0d 09 73 |dYear = |year;..s|
|00000680| 61 76 65 52 65 63 6f 72 | 64 28 29 3b 0d 7d 0d 0d |aveRecor|d();.}..|
|00000690| 0d 0d 69 6e 74 20 6d 61 | 69 6e 28 29 0d 7b 0d 09 |..int ma|in().{..|
|000006a0| 63 6f 75 74 20 3c 3c 20 | 22 4f 4f 46 49 4c 45 20 |cout << |"OOFILE |
|000006b0| 56 61 6c 69 64 61 74 69 | 6f 6e 20 53 75 69 74 65 |Validati|on Suite|
|000006c0| 20 2d 20 54 65 73 74 20 | 31 32 5c 6e 22 0d 09 09 | - Test |12\n"...|
|000006d0| 20 3c 3c 20 22 53 69 6d | 70 6c 65 20 74 65 73 74 | << "Sim|ple test|
|000006e0| 20 74 6f 20 62 75 69 6c | 64 20 63 6f 6d 70 6f 75 | to buil|d compou|
|000006f0| 6e 64 20 69 6e 64 65 78 | 65 73 5c 6e 22 0d 09 09 |nd index|es\n"...|
|00000700| 20 3c 3c 20 22 61 6e 64 | 20 64 65 6d 6f 6e 73 74 | << "and| demonst|
|00000710| 72 61 74 65 20 73 6f 72 | 74 69 6e 67 20 61 6e 64 |rate sor|ting and|
|00000720| 20 73 65 61 72 63 68 69 | 6e 67 20 62 79 20 74 68 | searchi|ng by th|
|00000730| 65 6d 20 61 6e 64 20 74 | 68 65 69 72 20 63 6f 6d |em and t|heir com|
|00000740| 70 6f 6e 65 6e 74 73 5c | 6e 22 3b 0d 09 0d 09 64 |ponents\|n";....d|
|00000750| 62 43 6f 6e 6e 65 63 74 | 5f 63 74 72 65 65 20 20 |bConnect|_ctree  |
|00000760| 20 20 74 68 65 44 42 3b | 0d 09 64 62 50 65 6f 70 |  theDB;|..dbPeop|
|00000770| 6c 65 20 20 20 20 20 50 | 65 6f 70 6c 65 3b 0d 09 |le     P|eople;..|
|00000780| 0d 09 69 66 20 28 64 62 | 43 6f 6e 6e 65 63 74 3a |..if (db|Connect:|
|00000790| 3a 66 69 6c 65 45 78 69 | 73 74 73 28 22 6f 6f 66 |:fileExi|sts("oof|
|000007a0| 74 73 74 31 32 2e 64 62 | 22 29 29 0d 09 09 74 68 |tst12.db|"))...th|
|000007b0| 65 44 42 2e 6f 70 65 6e | 43 6f 6e 6e 65 63 74 69 |eDB.open|Connecti|
|000007c0| 6f 6e 28 22 6f 6f 66 74 | 73 74 31 32 2e 64 62 22 |on("ooft|st12.db"|
|000007d0| 29 3b 0d 09 65 6c 73 65 | 20 7b 0d 09 09 74 68 65 |);..else| {...the|
|000007e0| 44 42 2e 6e 65 77 43 6f | 6e 6e 65 63 74 69 6f 6e |DB.newCo|nnection|
|000007f0| 28 22 6f 6f 66 74 73 74 | 31 32 2e 64 62 22 29 3b |("ooftst|12.db");|
|00000800| 0d 09 09 50 65 6f 70 6c | 65 2e 41 64 64 28 22 53 |...Peopl|e.Add("S|
|00000810| 6d 69 74 68 22 2c 20 22 | 4a 6f 68 6e 22 2c 20 30 |mith", "|John", 0|
|00000820| 2c 20 22 41 63 63 22 2c | 20 22 58 58 58 22 2c 20 |, "Acc",| "XXX", |
|00000830| 31 39 37 30 29 3b 20 20 | 2f 2f 20 73 70 65 63 69 |1970);  |// speci|
|00000840| 66 69 63 61 6c 6c 79 20 | 74 6f 20 74 65 73 74 20 |fically |to test |
|00000850| 7a 65 72 6f 20 73 65 61 | 72 63 68 65 73 0d 09 09 |zero sea|rches...|
|00000860| 50 65 6f 70 6c 65 2e 41 | 64 64 28 22 44 45 4e 54 |People.A|dd("DENT|
|00000870| 22 2c 20 22 54 72 69 73 | 73 61 22 2c 20 35 30 30 |", "Tris|sa", 500|
|00000880| 30 2c 20 22 41 63 63 22 | 2c 20 22 52 65 63 22 2c |0, "Acc"|, "Rec",|
|00000890| 20 31 39 38 35 29 3b 0d | 09 09 50 65 6f 70 6c 65 | 1985);.|..People|
|000008a0| 2e 41 64 64 28 22 44 65 | 6e 74 22 2c 20 22 41 6e |.Add("De|nt", "An|
|000008b0| 64 79 22 2c 20 32 35 30 | 30 30 2c 20 22 41 63 63 |dy", 250|00, "Acc|
|000008c0| 22 2c 20 22 58 58 58 22 | 2c 20 31 39 39 32 29 3b |", "XXX"|, 1992);|
|000008d0| 0d 09 09 50 65 6f 70 6c | 65 2e 41 64 64 28 22 44 |...Peopl|e.Add("D|
|000008e0| 65 6e 74 22 2c 20 22 41 | 6e 64 72 65 77 22 2c 20 |ent", "A|ndrew", |
|000008f0| 34 30 30 30 30 2c 20 22 | 4d 49 53 22 2c 20 22 42 |40000, "|MIS", "B|
|00000900| 6f 73 73 22 2c 20 31 39 | 38 32 29 3b 20 20 2f 2f |oss", 19|82);  //|
|00000910| 20 73 68 6f 75 6c 64 20 | 73 6f 72 74 20 62 65 66 | should |sort bef|
|00000920| 6f 72 65 20 41 6e 64 79 | 20 6f 6e 20 43 6f 6d 62 |ore Andy| on Comb|
|00000930| 69 6e 65 64 4e 61 6d 65 | 73 20 62 75 74 20 61 66 |inedName|s but af|
|00000940| 74 65 72 20 6f 6e 20 53 | 61 6c 61 72 79 0d 09 09 |ter on S|alary...|
|00000950| 50 65 6f 70 6c 65 2e 41 | 64 64 28 22 44 65 6e 74 |People.A|dd("Dent|
|00000960| 6f 6e 22 2c 20 22 41 6e | 64 72 65 77 22 2c 20 33 |on", "An|drew", 3|
|00000970| 39 30 30 30 2c 20 22 50 | 75 72 22 2c 20 22 58 58 |9000, "P|ur", "XX|
|00000980| 58 22 2c 20 31 39 39 34 | 29 3b 20 20 0d 09 09 50 |X", 1994|);  ...P|
|00000990| 65 6f 70 6c 65 2e 41 64 | 64 28 22 54 61 79 6c 6f |eople.Ad|d("Taylo|
|000009a0| 72 22 2c 20 22 4b 65 6e | 22 2c 20 37 35 30 30 30 |r", "Ken|", 75000|
|000009b0| 2c 20 22 4d 49 53 22 2c | 20 22 43 6e 74 72 22 2c |, "MIS",| "Cntr",|
|000009c0| 20 31 39 39 34 29 3b 0d | 09 7d 0d 09 0d 09 50 65 | 1994);.|.}....Pe|
|000009d0| 6f 70 6c 65 2e 73 65 6c | 65 63 74 41 6c 6c 28 29 |ople.sel|ectAll()|
|000009e0| 3b 0d 09 50 65 6f 70 6c | 65 2e 73 65 74 53 6f 72 |;..Peopl|e.setSor|
|000009f0| 74 4f 72 64 65 72 28 50 | 65 6f 70 6c 65 2e 43 6f |tOrder(P|eople.Co|
|00000a00| 6d 62 69 6e 65 64 4e 61 | 6d 65 73 29 3b 0d 09 63 |mbinedNa|mes);..c|
|00000a10| 6f 75 74 20 3c 3c 20 22 | 4c 69 73 74 69 6e 67 20 |out << "|Listing |
|00000a20| 72 65 63 6f 72 64 73 20 | 62 79 20 63 6f 6d 62 69 |records |by combi|
|00000a30| 6e 65 64 20 6e 61 6d 65 | 73 5c 6e 22 20 3c 3c 20 |ned name|s\n" << |
|00000a40| 50 65 6f 70 6c 65 20 3c | 3c 20 65 6e 64 6c 3b 0d |People <|< endl;.|
|00000a50| 0d 09 50 65 6f 70 6c 65 | 2e 73 65 74 53 6f 72 74 |..People|.setSort|
|00000a60| 4f 72 64 65 72 28 50 65 | 6f 70 6c 65 2e 4e 61 6d |Order(Pe|ople.Nam|
|00000a70| 65 41 6e 64 53 61 6c 61 | 72 79 29 3b 0d 09 63 6f |eAndSala|ry);..co|
|00000a80| 75 74 20 3c 3c 20 22 4c | 69 73 74 69 6e 67 20 72 |ut << "L|isting r|
|00000a90| 65 63 6f 72 64 73 20 62 | 79 20 4e 61 6d 65 20 61 |ecords b|y Name a|
|00000aa0| 6e 64 20 72 65 76 65 72 | 73 65 20 53 61 6c 61 72 |nd rever|se Salar|
|00000ab0| 79 5c 6e 22 20 3c 3c 20 | 50 65 6f 70 6c 65 20 3c |y\n" << |People <|
|00000ac0| 3c 20 65 6e 64 6c 3b 0d | 0d 09 50 65 6f 70 6c 65 |< endl;.|..People|
|00000ad0| 2e 73 65 74 53 6f 72 74 | 4f 72 64 65 72 28 50 65 |.setSort|Order(Pe|
|00000ae0| 6f 70 6c 65 2e 4f 74 68 | 65 72 4e 61 6d 65 73 29 |ople.Oth|erNames)|
|00000af0| 3b 0d 09 63 6f 75 74 20 | 3c 3c 20 22 4c 69 73 74 |;..cout |<< "List|
|00000b00| 69 6e 67 20 72 65 63 6f | 72 64 73 20 69 6e 20 4f |ing reco|rds in O|
|00000b10| 74 68 65 72 4e 61 6d 65 | 73 20 6f 72 64 65 72 5c |therName|s order\|
|00000b20| 6e 22 20 3c 3c 20 50 65 | 6f 70 6c 65 20 3c 3c 20 |n" << Pe|ople << |
|00000b30| 65 6e 64 6c 3b 0d 0d 2f | 2a 20 42 52 4f 4b 45 4e |endl;../|* BROKEN|
|00000b40| 20 69 6e 20 76 31 2e 31 | 2e 31 20 2d 20 72 65 75 | in v1.1|.1 - reu|
|00000b50| 73 65 20 6f 66 20 63 6f | 6d 70 6f 75 6e 64 20 69 |se of co|mpound i|
|00000b60| 6e 64 65 78 20 62 79 20 | 73 69 6e 67 6c 65 20 6e |ndex by |single n|
|00000b70| 6f 6e 2d 69 6e 64 65 78 | 65 64 20 66 69 65 6c 64 |on-index|ed field|
|00000b80| 73 0d 09 50 65 6f 70 6c | 65 2e 73 65 61 72 63 68 |s..Peopl|e.search|
|00000b90| 28 50 65 6f 70 6c 65 2e | 4c 61 73 74 4e 61 6d 65 |(People.|LastName|
|00000ba0| 3d 3d 22 44 65 6e 74 22 | 29 3b 20 20 2f 2f 20 75 |=="Dent"|);  // u|
|00000bb0| 73 65 73 20 63 6f 6d 70 | 6f 75 6e 64 20 69 6e 64 |ses comp|ound ind|
|00000bc0| 65 78 0d 09 63 6f 75 74 | 20 3c 3c 20 22 4c 69 73 |ex..cout| << "Lis|
|00000bd0| 74 69 6e 67 20 74 68 72 | 65 65 20 44 65 6e 74 20 |ting thr|ee Dent |
|00000be0| 72 65 63 6f 72 64 73 3a | 20 22 20 3c 3c 20 65 6e |records:| " << en|
|00000bf0| 64 6c 20 3c 3c 20 50 65 | 6f 70 6c 65 20 3c 3c 20 |dl << Pe|ople << |
|00000c00| 65 6e 64 6c 3b 0d 0d 09 | 50 65 6f 70 6c 65 2e 73 |endl;...|People.s|
|00000c10| 65 61 72 63 68 28 50 65 | 6f 70 6c 65 2e 4a 6f 62 |earch(Pe|ople.Job|
|00000c20| 43 6f 64 65 2e 73 74 61 | 72 74 73 57 69 74 68 28 |Code.sta|rtsWith(|
|00000c30| 22 41 63 63 58 58 58 22 | 29 29 3b 20 20 2f 2f 20 |"AccXXX"|));  // |
|00000c40| 75 73 65 73 20 63 6f 6d | 70 6f 75 6e 64 20 69 6e |uses com|pound in|
|00000c50| 64 65 78 20 69 6e 20 64 | 69 72 65 63 74 20 71 75 |dex in d|irect qu|
|00000c60| 65 72 79 0d 09 63 6f 75 | 74 20 3c 3c 20 22 4c 69 |ery..cou|t << "Li|
|00000c70| 73 74 69 6e 67 20 74 77 | 6f 20 41 63 63 58 58 58 |sting tw|o AccXXX|
|00000c80| 20 72 65 63 6f 72 64 73 | 3a 20 22 20 3c 3c 20 65 | records|: " << e|
|00000c90| 6e 64 6c 20 3c 3c 20 50 | 65 6f 70 6c 65 20 3c 3c |ndl << P|eople <<|
|00000ca0| 20 65 6e 64 6c 3b 0d 2a | 2f 0d 0d 09 50 65 6f 70 | endl;.*|/...Peop|
|00000cb0| 6c 65 5b 50 65 6f 70 6c | 65 2e 4c 61 73 74 4e 61 |le[Peopl|e.LastNa|
|00000cc0| 6d 65 3d 3d 22 44 65 6e | 74 22 20 26 26 20 50 65 |me=="Den|t" && Pe|
|00000cd0| 6f 70 6c 65 2e 53 61 6c | 61 72 79 3d 3d 32 35 30 |ople.Sal|ary==250|
|00000ce0| 30 30 5d 3b 0d 09 63 6f | 75 74 20 3c 3c 20 22 4c |00];..co|ut << "L|
|00000cf0| 69 73 74 69 6e 67 20 41 | 6e 64 79 20 44 65 6e 74 |isting A|ndy Dent|
|00000d00| 20 62 79 20 63 6f 6d 70 | 6f 75 6e 64 20 6b 65 79 | by comp|ound key|
|00000d10| 20 73 65 61 72 63 68 20 | 6f 66 20 4c 61 73 74 4e | search |of LastN|
|00000d20| 61 6d 65 20 26 20 53 61 | 6c 61 72 79 3a 20 22 20 |ame & Sa|lary: " |
|00000d30| 3c 3c 20 65 6e 64 6c 20 | 3c 3c 20 50 65 6f 70 6c |<< endl |<< Peopl|
|00000d40| 65 20 3c 3c 20 65 6e 64 | 6c 3b 0d 0d 09 50 65 6f |e << end|l;...Peo|
|00000d50| 70 6c 65 5b 50 65 6f 70 | 6c 65 2e 4c 61 73 74 4e |ple[Peop|le.LastN|
|00000d60| 61 6d 65 3d 3d 22 44 65 | 6e 74 22 20 26 26 20 50 |ame=="De|nt" && P|
|00000d70| 65 6f 70 6c 65 2e 4f 74 | 68 65 72 4e 61 6d 65 73 |eople.Ot|herNames|
|00000d80| 3d 3d 22 41 6e 64 72 65 | 77 22 5d 3b 0d 09 63 6f |=="Andre|w"];..co|
|00000d90| 75 74 20 3c 3c 20 22 4c | 69 73 74 69 6e 67 20 41 |ut << "L|isting A|
|00000da0| 6e 64 72 65 77 20 44 65 | 6e 74 20 62 79 20 63 6f |ndrew De|nt by co|
|00000db0| 6d 70 6f 75 6e 64 20 6b | 65 79 20 73 65 61 72 63 |mpound k|ey searc|
|00000dc0| 68 20 6f 6e 20 62 6f 74 | 68 20 6e 61 6d 65 73 3a |h on bot|h names:|
|00000dd0| 20 22 20 3c 3c 20 65 6e | 64 6c 20 3c 3c 20 50 65 | " << en|dl << Pe|
|00000de0| 6f 70 6c 65 20 3c 3c 20 | 65 6e 64 6c 3b 0d 0d 2f |ople << |endl;../|
|00000df0| 2f 20 63 6f 6d 62 69 6e | 61 74 6f 72 69 61 6c 20 |/ combin|atorial |
|00000e00| 73 65 61 72 63 68 0d 09 | 50 65 6f 70 6c 65 5b 20 |search..|People[ |
|00000e10| 28 50 65 6f 70 6c 65 2e | 4c 61 73 74 4e 61 6d 65 |(People.|LastName|
|00000e20| 3d 3d 22 44 65 6e 74 22 | 20 26 26 20 50 65 6f 70 |=="Dent"| && Peop|
|00000e30| 6c 65 2e 53 61 6c 61 72 | 79 3d 3d 32 35 30 30 30 |le.Salar|y==25000|
|00000e40| 29 20 0d 09 09 09 7c 20 | 50 65 6f 70 6c 65 2e 4f |) ....| |People.O|
|00000e50| 74 68 65 72 4e 61 6d 65 | 73 3d 3d 22 41 6e 64 72 |therName|s=="Andr|
|00000e60| 65 77 22 0d 09 5d 3b 0d | 09 63 6f 75 74 20 3c 3c |ew"..];.|.cout <<|
|00000e70| 20 22 4c 69 73 74 69 6e | 67 20 41 6e 64 79 20 44 | "Listin|g Andy D|
|00000e80| 65 6e 74 20 26 20 44 65 | 6e 74 6f 6e 3a 20 22 20 |ent & De|nton: " |
|00000e90| 3c 3c 20 65 6e 64 6c 20 | 3c 3c 20 50 65 6f 70 6c |<< endl |<< Peopl|
|00000ea0| 65 20 3c 3c 20 65 6e 64 | 6c 3b 0d 0d 09 63 6f 75 |e << end|l;...cou|
|00000eb0| 74 20 3c 3c 20 22 54 65 | 73 74 20 47 65 74 74 69 |t << "Te|st Getti|
|00000ec0| 6e 67 20 63 6f 70 79 20 | 66 72 6f 6d 20 72 65 61 |ng copy |from rea|
|00000ed0| 64 2d 6f 6e 6c 79 20 63 | 6f 6d 70 6f 75 6e 64 20 |d-only c|ompound |
|00000ee0| 66 69 65 6c 64 22 20 3c | 3c 20 65 6e 64 6c 3b 0d |field" <|< endl;.|
|00000ef0| 09 50 65 6f 70 6c 65 2e | 73 74 61 72 74 28 29 3b |.People.|start();|
|00000f00| 0d 09 63 68 61 72 2a 20 | 73 74 72 20 3d 20 50 65 |..char* |str = Pe|
|00000f10| 6f 70 6c 65 2e 4a 6f 62 | 43 6f 64 65 2e 63 6f 70 |ople.Job|Code.cop|
|00000f20| 79 41 73 43 68 61 72 73 | 28 29 3b 0d 09 63 6f 75 |yAsChars|();..cou|
|00000f30| 74 20 3c 3c 20 22 4a 6f | 62 43 6f 64 65 20 69 73 |t << "Jo|bCode is|
|00000f40| 3a 20 22 20 3c 3c 20 73 | 74 72 20 3c 3c 20 65 6e |: " << s|tr << en|
|00000f50| 64 6c 3b 0d 09 64 65 6c | 65 74 65 5b 5d 20 73 74 |dl;..del|ete[] st|
|00000f60| 72 3b 0d 0d 09 64 62 50 | 65 6f 70 6c 65 20 50 65 |r;...dbP|eople Pe|
|00000f70| 6f 70 6c 65 32 28 50 65 | 6f 70 6c 65 29 3b 0d 09 |ople2(Pe|ople);..|
|00000f80| 50 65 6f 70 6c 65 32 2e | 73 74 61 72 74 28 29 3b |People2.|start();|
|00000f90| 20 20 2f 2f 20 74 68 69 | 73 20 6f 72 20 61 20 73 |  // thi|s or a s|
|00000fa0| 65 61 72 63 68 20 69 73 | 20 2a 2a 2a 65 73 73 65 |earch is| ***esse|
|00000fb0| 6e 74 69 61 6c 2a 2a 2a | 20 61 66 74 65 72 20 63 |ntial***| after c|
|00000fc0| 6c 6f 6e 69 6e 67 20 61 | 20 73 65 6c 65 63 74 69 |loning a| selecti|
|00000fd0| 6f 6e 0d 09 63 6f 75 74 | 20 3c 3c 20 65 6e 64 6c |on..cout| << endl|
|00000fe0| 20 3c 3c 20 22 52 65 70 | 65 61 74 20 61 62 6f 76 | << "Rep|eat abov|
|00000ff0| 65 20 72 65 61 64 2d 6f | 6e 6c 79 20 63 6f 6d 70 |e read-o|nly comp|
|00001000| 6f 75 6e 64 20 66 69 65 | 6c 64 20 74 65 73 74 20 |ound fie|ld test |
|00001010| 6f 6e 20 63 6c 6f 6e 65 | 64 20 73 65 6c 65 63 74 |on clone|d select|
|00001020| 69 6f 6e 22 20 3c 3c 20 | 65 6e 64 6c 3b 0d 09 63 |ion" << |endl;..c|
|00001030| 6f 75 74 20 3c 3c 20 22 | 4a 6f 62 43 6f 64 65 20 |out << "|JobCode |
|00001040| 69 73 3a 20 22 20 3c 3c | 20 50 65 6f 70 6c 65 32 |is: " <<| People2|
|00001050| 2e 4a 6f 62 43 6f 64 65 | 20 3c 3c 20 65 6e 64 6c |.JobCode| << endl|
|00001060| 3b 0d 0d 09 63 6f 75 74 | 20 3c 3c 20 65 6e 64 6c |;...cout| << endl|
|00001070| 20 3c 3c 20 22 54 65 73 | 74 20 43 6f 6d 70 6c 65 | << "Tes|t Comple|
|00001080| 74 65 64 22 20 3c 3c 20 | 65 6e 64 6c 3b 0d 09 0d |ted" << |endl;...|
|00001090| 09 72 65 74 75 72 6e 20 | 45 58 49 54 5f 53 55 43 |.return |EXIT_SUC|
|000010a0| 43 45 53 53 3b 0d 7d 20 | 0d 00 00 00 00 00 00 00 |CESS;.} |........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 00 01 00 00 00 01 f6 | 00 00 00 f6 00 00 00 7a |........|.......z|
|00001110| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00001120| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00001130| 0c 6f 6f 66 74 73 74 31 | 32 2e 63 70 70 31 02 00 |.ooftst1|2.cpp1..|
|00001140| 00 00 50 61 72 74 53 49 | 54 21 00 00 00 00 00 00 |..PartSI|T!......|
|00001150| 00 00 50 61 72 74 53 49 | 54 21 00 00 00 00 00 00 |..PartSI|T!......|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 b0 1b 75 f8 00 00 | 00 00 00 00 02 70 ff ff |....u...|.....p..|
|00001180| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00001190| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000011f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00001200| 00 00 00 78 00 03 00 00 | 00 48 00 48 00 00 00 00 |...x....|.H.H....|
|00001210| 03 0d 02 1a ff e2 ff e3 | 03 2c 02 36 03 47 05 7b |........|.,.6.G.{|
|00001220| 03 e0 00 02 00 00 00 48 | 00 48 00 00 00 00 02 d8 |.......H|.H......|
|00001230| 02 28 00 01 00 00 00 64 | 00 00 00 01 00 03 03 03 |.(.....d|........|
|00001240| 00 ff 00 01 27 0f 00 01 | 00 01 00 00 00 00 00 00 |....'...|........|
|00001250| 00 00 00 00 00 00 60 08 | 00 19 01 90 00 00 00 00 |......`.|........|
|00001260| 00 00 00 00 00 00 00 00 | 00 00 00 01 00 00 00 00 |........|........|
|00001270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 16 |........|........|
|00001280| 01 00 00 00 00 00 00 00 | 01 00 01 00 00 07 07 43 |........|.......C|
|00001290| 6f 75 72 69 65 72 00 00 | 00 08 00 00 00 00 00 00 |ourier..|........|
|000012a0| 00 00 00 00 00 48 00 09 | 4d 6f 6e 61 63 6f 00 00 |.....H..|Monaco..|
|000012b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012c0| 00 00 00 00 00 00 00 00 | 00 03 00 04 00 56 00 04 |........|.....V..|
|000012d0| 01 df 02 5e 00 56 00 04 | 01 df 02 5e af 69 41 6c |...^.V..|...^.iAl|
|000012e0| 00 00 00 00 00 00 00 00 | 00 00 06 1d 01 00 00 00 |........|........|
|000012f0| 00 04 00 01 00 01 00 00 | 01 00 00 00 01 f6 00 00 |........|........|
|00001300| 00 f6 00 00 00 7a 01 a3 | eb 50 2a f8 00 00 00 1c |.....z..|.P*.....|
|00001310| 00 7a 00 03 4d 50 53 52 | 00 01 00 22 46 50 52 46 |.z..MPSR|..."FPRF|
|00001320| 00 00 00 3a 46 50 72 66 | 00 00 00 46 4d 57 42 42 |...:FPrf|...FMWBB|
|00001330| 00 00 00 52 03 ee ff ff | 00 00 00 00 00 00 00 00 |...R....|........|
|00001340| 03 ed ff ff 00 00 00 a2 | 00 00 00 00 05 1a ff ff |........|........|
|00001350| 00 00 00 7c 00 00 00 00 | 05 1a ff ff 00 00 00 96 |...|....|........|
|00001360| 00 00 00 00 03 f0 ff ff | 00 00 00 ee 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+